﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="MakeITDataSet" targetNamespace="http://tempuri.org/MakeITDataSet.xsd" xmlns:mstns="http://tempuri.org/MakeITDataSet.xsd" xmlns="http://tempuri.org/MakeITDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="MakeITConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MakeITConnectionString (Settings)" PropertyReference="ApplicationSettings.MakeIT_Bill_Maker.Properties.Settings.GlobalReference.Default.MakeITConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ChargesTableAdapter" GeneratorDataComponentClassName="ChargesTableAdapter" Name="Charges" UserDataComponentName="ChargesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MakeITConnectionString (Settings)" DbObjectName="Charges" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Charges` (`Units`, `Charge`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Units" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Units" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Charge" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Charge" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Units, Charge FROM Charges</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Units" DataSetColumn="Units" />
              <Mapping SourceColumn="Charge" DataSetColumn="Charge" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="otherFixedTableAdapter" GeneratorDataComponentClassName="otherFixedTableAdapter" Name="otherFixed" UserDataComponentName="otherFixedTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MakeITConnectionString (Settings)" DbObjectName="otherFixed" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `otherFixed` WHERE ((`BillNo` = ?) AND ((? = 1 AND `ServiceCharge` IS NULL) OR (`ServiceCharge` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_BillNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BillNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ServiceCharge" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ServiceCharge" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ServiceCharge" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ServiceCharge" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `otherFixed` (`BillNo`, `ServiceCharge`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="BillNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BillNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ServiceCharge" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ServiceCharge" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT BillNo, ServiceCharge FROM otherFixed</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `otherFixed` SET `BillNo` = ?, `ServiceCharge` = ? WHERE ((`BillNo` = ?) AND ((? = 1 AND `ServiceCharge` IS NULL) OR (`ServiceCharge` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="BillNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BillNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ServiceCharge" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ServiceCharge" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_BillNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BillNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ServiceCharge" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ServiceCharge" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ServiceCharge" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ServiceCharge" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BillNo" DataSetColumn="BillNo" />
              <Mapping SourceColumn="ServiceCharge" DataSetColumn="ServiceCharge" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MakeITConnectionString (Settings)" DbObjectName="Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Users` WHERE ((`AptIndexNo` = ?) AND ((? = 1 AND `AptNo` IS NULL) OR (`AptNo` = ?)) AND ((? = 1 AND `Name` IS NULL) OR (`Name` = ?)) AND ((? = 1 AND `MeterNo` IS NULL) OR (`MeterNo` = ?)) AND ((? = 1 AND `Arrears` IS NULL) OR (`Arrears` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AptIndexNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AptIndexNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AptNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AptNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AptNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AptNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MeterNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MeterNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_MeterNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MeterNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Arrears" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Arrears" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Arrears" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Arrears" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Users` (`AptNo`, `Name`, `MeterNo`, `Arrears`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AptNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AptNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="MeterNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MeterNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Arrears" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Arrears" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT AptIndexNo, AptNo, Name, MeterNo, Arrears FROM Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Users` SET `AptNo` = ?, `Name` = ?, `MeterNo` = ?, `Arrears` = ? WHERE ((`AptIndexNo` = ?) AND ((? = 1 AND `AptNo` IS NULL) OR (`AptNo` = ?)) AND ((? = 1 AND `Name` IS NULL) OR (`Name` = ?)) AND ((? = 1 AND `MeterNo` IS NULL) OR (`MeterNo` = ?)) AND ((? = 1 AND `Arrears` IS NULL) OR (`Arrears` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AptNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AptNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="MeterNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MeterNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Arrears" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Arrears" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AptIndexNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AptIndexNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AptNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AptNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AptNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AptNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MeterNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MeterNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_MeterNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MeterNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Arrears" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Arrears" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Arrears" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Arrears" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AptIndexNo" DataSetColumn="AptIndexNo" />
              <Mapping SourceColumn="AptNo" DataSetColumn="AptNo" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="MeterNo" DataSetColumn="MeterNo" />
              <Mapping SourceColumn="Arrears" DataSetColumn="Arrears" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersMonthlyTableAdapter" GeneratorDataComponentClassName="UsersMonthlyTableAdapter" Name="UsersMonthly" UserDataComponentName="UsersMonthlyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MakeITConnectionString (Settings)" DbObjectName="UsersMonthly" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `UsersMonthly` WHERE ((`IndexNo` = ?) AND ((? = 1 AND `BillNo` IS NULL) OR (`BillNo` = ?)) AND ((? = 1 AND `PrevReadDate` IS NULL) OR (`PrevReadDate` = ?)) AND ((? = 1 AND `PrevRead` IS NULL) OR (`PrevRead` = ?)) AND ((? = 1 AND `CurrReadDate` IS NULL) OR (`CurrReadDate` = ?)) AND ((? = 1 AND `CurrRead` IS NULL) OR (`CurrRead` = ?)) AND ((? = 1 AND `UnitsConsumed` IS NULL) OR (`UnitsConsumed` = ?)) AND ((? = 1 AND `Charge` IS NULL) OR (`Charge` = ?)) AND ((? = 1 AND `Arrears` IS NULL) OR (`Arrears` = ?)) AND ((? = 1 AND `TotalAmount` IS NULL) OR (`TotalAmount` = ?)) AND ((? = 1 AND `FinalDateOfPayment` IS NULL) OR (`FinalDateOfPayment` = ?)) AND ((? = 1 AND `IsPaid` IS NULL) OR (`IsPaid` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IndexNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IndexNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BillNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BillNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_BillNo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BillNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrevReadDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrevReadDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PrevReadDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PrevReadDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrevRead" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrevRead" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PrevRead" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PrevRead" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CurrReadDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CurrReadDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CurrReadDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CurrReadDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CurrRead" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CurrRead" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CurrRead" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CurrRead" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UnitsConsumed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UnitsConsumed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UnitsConsumed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UnitsConsumed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Charge" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Charge" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Charge" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Charge" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Arrears" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Arrears" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Arrears" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Arrears" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TotalAmount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TotalAmount" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FinalDateOfPayment" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FinalDateOfPayment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_FinalDateOfPayment" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FinalDateOfPayment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsPaid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsPaid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsPaid" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `UsersMonthly` (`BillNo`, `PrevReadDate`, `PrevRead`, `CurrReadDate`, `CurrRead`, `UnitsConsumed`, `Charge`, `Arrears`, `TotalAmount`, `FinalDateOfPayment`, `IsPaid`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BillNo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BillNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PrevReadDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PrevReadDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PrevRead" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PrevRead" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CurrReadDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CurrReadDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CurrRead" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CurrRead" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UnitsConsumed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UnitsConsumed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Charge" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Charge" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Arrears" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Arrears" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TotalAmount" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FinalDateOfPayment" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FinalDateOfPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsPaid" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IndexNo, BillNo, PrevReadDate, PrevRead, CurrReadDate, CurrRead, UnitsConsumed, Charge, Arrears, TotalAmount, FinalDateOfPayment, IsPaid
FROM         UsersMonthly</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `UsersMonthly` SET `BillNo` = ?, `PrevReadDate` = ?, `PrevRead` = ?, `CurrReadDate` = ?, `CurrRead` = ?, `UnitsConsumed` = ?, `Charge` = ?, `Arrears` = ?, `TotalAmount` = ?, `FinalDateOfPayment` = ?, `IsPaid` = ? WHERE ((`IndexNo` = ?) AND ((? = 1 AND `BillNo` IS NULL) OR (`BillNo` = ?)) AND ((? = 1 AND `PrevReadDate` IS NULL) OR (`PrevReadDate` = ?)) AND ((? = 1 AND `PrevRead` IS NULL) OR (`PrevRead` = ?)) AND ((? = 1 AND `CurrReadDate` IS NULL) OR (`CurrReadDate` = ?)) AND ((? = 1 AND `CurrRead` IS NULL) OR (`CurrRead` = ?)) AND ((? = 1 AND `UnitsConsumed` IS NULL) OR (`UnitsConsumed` = ?)) AND ((? = 1 AND `Charge` IS NULL) OR (`Charge` = ?)) AND ((? = 1 AND `Arrears` IS NULL) OR (`Arrears` = ?)) AND ((? = 1 AND `TotalAmount` IS NULL) OR (`TotalAmount` = ?)) AND ((? = 1 AND `FinalDateOfPayment` IS NULL) OR (`FinalDateOfPayment` = ?)) AND ((? = 1 AND `IsPaid` IS NULL) OR (`IsPaid` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BillNo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BillNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PrevReadDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PrevReadDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PrevRead" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PrevRead" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CurrReadDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CurrReadDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CurrRead" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CurrRead" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UnitsConsumed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UnitsConsumed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Charge" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Charge" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Arrears" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Arrears" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TotalAmount" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FinalDateOfPayment" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FinalDateOfPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsPaid" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IndexNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IndexNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BillNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BillNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_BillNo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BillNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrevReadDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrevReadDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PrevReadDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PrevReadDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrevRead" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrevRead" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PrevRead" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PrevRead" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CurrReadDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CurrReadDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CurrReadDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CurrReadDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CurrRead" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CurrRead" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CurrRead" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CurrRead" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UnitsConsumed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UnitsConsumed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UnitsConsumed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UnitsConsumed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Charge" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Charge" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Charge" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Charge" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Arrears" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Arrears" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Arrears" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Arrears" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TotalAmount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TotalAmount" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FinalDateOfPayment" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FinalDateOfPayment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_FinalDateOfPayment" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FinalDateOfPayment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsPaid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsPaid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsPaid" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IndexNo" DataSetColumn="IndexNo" />
              <Mapping SourceColumn="BillNo" DataSetColumn="BillNo" />
              <Mapping SourceColumn="PrevRead" DataSetColumn="PrevRead" />
              <Mapping SourceColumn="CurrReadDate" DataSetColumn="CurrReadDate" />
              <Mapping SourceColumn="CurrRead" DataSetColumn="CurrRead" />
              <Mapping SourceColumn="UnitsConsumed" DataSetColumn="UnitsConsumed" />
              <Mapping SourceColumn="Charge" DataSetColumn="Charge" />
              <Mapping SourceColumn="Arrears" DataSetColumn="Arrears" />
              <Mapping SourceColumn="TotalAmount" DataSetColumn="TotalAmount" />
              <Mapping SourceColumn="FinalDateOfPayment" DataSetColumn="FinalDateOfPayment" />
              <Mapping SourceColumn="IsPaid" DataSetColumn="IsPaid" />
              <Mapping SourceColumn="PrevReadDate" DataSetColumn="PrevReadDate" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="MakeITConnectionString (Settings)" DbObjectName="UsersMonthly" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT     IndexNo, BillNo, PrevReadDate, PrevRead, CurrReadDate, CurrRead, UnitsConsumed, Charge, Arrears, TotalAmount, FinalDateOfPayment, IsPaid
FROM         UsersMonthly</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="MakeITConnectionString (Settings)" DbObjectName="UsersMonthly" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="GetUnpaid" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="GetUnpaid" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetUnpaid">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Arrears, BillNo, Charge, CurrRead, CurrReadDate, FinalDateOfPayment, IndexNo, IsPaid, PrevRead, PrevReadDate, TotalAmount, UnitsConsumed FROM UsersMonthly WHERE (IsPaid = 0)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="MakeITDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="MakeITDataSet" msprop:Generator_UserDSName="MakeITDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Charges" msprop:Generator_TableClassName="ChargesDataTable" msprop:Generator_TableVarName="tableCharges" msprop:Generator_TablePropName="Charges" msprop:Generator_RowDeletingName="ChargesRowDeleting" msprop:Generator_UserTableName="Charges" msprop:Generator_RowChangingName="ChargesRowChanging" msprop:Generator_RowEvHandlerName="ChargesRowChangeEventHandler" msprop:Generator_RowDeletedName="ChargesRowDeleted" msprop:Generator_RowEvArgName="ChargesRowChangeEvent" msprop:Generator_RowChangedName="ChargesRowChanged" msprop:Generator_RowClassName="ChargesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Units" msprop:Generator_ColumnVarNameInTable="columnUnits" msprop:Generator_ColumnPropNameInRow="Units" msprop:Generator_ColumnPropNameInTable="UnitsColumn" msprop:Generator_UserColumnName="Units" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Charge" msprop:Generator_ColumnVarNameInTable="columnCharge" msprop:Generator_ColumnPropNameInRow="Charge" msprop:Generator_ColumnPropNameInTable="ChargeColumn" msprop:Generator_UserColumnName="Charge" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="otherFixed" msprop:Generator_TableClassName="otherFixedDataTable" msprop:Generator_TableVarName="tableotherFixed" msprop:Generator_TablePropName="otherFixed" msprop:Generator_RowDeletingName="otherFixedRowDeleting" msprop:Generator_UserTableName="otherFixed" msprop:Generator_RowChangingName="otherFixedRowChanging" msprop:Generator_RowEvHandlerName="otherFixedRowChangeEventHandler" msprop:Generator_RowDeletedName="otherFixedRowDeleted" msprop:Generator_RowEvArgName="otherFixedRowChangeEvent" msprop:Generator_RowChangedName="otherFixedRowChanged" msprop:Generator_RowClassName="otherFixedRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BillNo" msprop:Generator_ColumnVarNameInTable="columnBillNo" msprop:Generator_ColumnPropNameInRow="BillNo" msprop:Generator_ColumnPropNameInTable="BillNoColumn" msprop:Generator_UserColumnName="BillNo" type="xs:int" />
              <xs:element name="ServiceCharge" msprop:Generator_ColumnVarNameInTable="columnServiceCharge" msprop:Generator_ColumnPropNameInRow="ServiceCharge" msprop:Generator_ColumnPropNameInTable="ServiceChargeColumn" msprop:Generator_UserColumnName="ServiceCharge" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_TablePropName="Users" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_UserTableName="Users" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowClassName="UsersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AptIndexNo" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnAptIndexNo" msprop:Generator_ColumnPropNameInRow="AptIndexNo" msprop:Generator_ColumnPropNameInTable="AptIndexNoColumn" msprop:Generator_UserColumnName="AptIndexNo" type="xs:int" />
              <xs:element name="AptNo" msprop:Generator_ColumnVarNameInTable="columnAptNo" msprop:Generator_ColumnPropNameInRow="AptNo" msprop:Generator_ColumnPropNameInTable="AptNoColumn" msprop:Generator_UserColumnName="AptNo" type="xs:int" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MeterNo" msprop:Generator_ColumnVarNameInTable="columnMeterNo" msprop:Generator_ColumnPropNameInRow="MeterNo" msprop:Generator_ColumnPropNameInTable="MeterNoColumn" msprop:Generator_UserColumnName="MeterNo" type="xs:int" minOccurs="0" />
              <xs:element name="Arrears" msprop:Generator_ColumnVarNameInTable="columnArrears" msprop:Generator_ColumnPropNameInRow="Arrears" msprop:Generator_ColumnPropNameInTable="ArrearsColumn" msprop:Generator_UserColumnName="Arrears" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UsersMonthly" msprop:Generator_TableClassName="UsersMonthlyDataTable" msprop:Generator_TableVarName="tableUsersMonthly" msprop:Generator_TablePropName="UsersMonthly" msprop:Generator_RowDeletingName="UsersMonthlyRowDeleting" msprop:Generator_UserTableName="UsersMonthly" msprop:Generator_RowChangingName="UsersMonthlyRowChanging" msprop:Generator_RowEvHandlerName="UsersMonthlyRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersMonthlyRowDeleted" msprop:Generator_RowEvArgName="UsersMonthlyRowChangeEvent" msprop:Generator_RowChangedName="UsersMonthlyRowChanged" msprop:Generator_RowClassName="UsersMonthlyRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IndexNo" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIndexNo" msprop:Generator_ColumnPropNameInRow="IndexNo" msprop:Generator_ColumnPropNameInTable="IndexNoColumn" msprop:Generator_UserColumnName="IndexNo" type="xs:int" />
              <xs:element name="BillNo" msprop:Generator_ColumnVarNameInTable="columnBillNo" msprop:Generator_ColumnPropNameInRow="BillNo" msprop:Generator_ColumnPropNameInTable="BillNoColumn" msprop:Generator_UserColumnName="BillNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PrevRead" msprop:Generator_ColumnVarNameInTable="columnPrevRead" msprop:Generator_ColumnPropNameInRow="PrevRead" msprop:Generator_ColumnPropNameInTable="PrevReadColumn" msprop:Generator_UserColumnName="PrevRead" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CurrReadDate" msprop:Generator_ColumnVarNameInTable="columnCurrReadDate" msprop:Generator_ColumnPropNameInRow="CurrReadDate" msprop:Generator_ColumnPropNameInTable="CurrReadDateColumn" msprop:Generator_UserColumnName="CurrReadDate" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CurrRead" msprop:Generator_ColumnVarNameInTable="columnCurrRead" msprop:Generator_ColumnPropNameInRow="CurrRead" msprop:Generator_ColumnPropNameInTable="CurrReadColumn" msprop:Generator_UserColumnName="CurrRead" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UnitsConsumed" msprop:Generator_ColumnVarNameInTable="columnUnitsConsumed" msprop:Generator_ColumnPropNameInRow="UnitsConsumed" msprop:Generator_ColumnPropNameInTable="UnitsConsumedColumn" msprop:Generator_UserColumnName="UnitsConsumed" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Charge" msprop:Generator_ColumnVarNameInTable="columnCharge" msprop:Generator_ColumnPropNameInRow="Charge" msprop:Generator_ColumnPropNameInTable="ChargeColumn" msprop:Generator_UserColumnName="Charge" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Arrears" msprop:Generator_ColumnVarNameInTable="columnArrears" msprop:Generator_ColumnPropNameInRow="Arrears" msprop:Generator_ColumnPropNameInTable="ArrearsColumn" msprop:Generator_UserColumnName="Arrears" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TotalAmount" msprop:Generator_ColumnVarNameInTable="columnTotalAmount" msprop:Generator_ColumnPropNameInRow="TotalAmount" msprop:Generator_ColumnPropNameInTable="TotalAmountColumn" msprop:Generator_UserColumnName="TotalAmount" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FinalDateOfPayment" msprop:Generator_ColumnVarNameInTable="columnFinalDateOfPayment" msprop:Generator_ColumnPropNameInRow="FinalDateOfPayment" msprop:Generator_ColumnPropNameInTable="FinalDateOfPaymentColumn" msprop:Generator_UserColumnName="FinalDateOfPayment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsPaid" msprop:Generator_ColumnVarNameInTable="columnIsPaid" msprop:Generator_ColumnPropNameInRow="IsPaid" msprop:Generator_ColumnPropNameInTable="IsPaidColumn" msprop:Generator_UserColumnName="IsPaid" type="xs:boolean" minOccurs="0" />
              <xs:element name="PrevReadDate" msprop:Generator_ColumnVarNameInTable="columnPrevReadDate" msprop:Generator_ColumnPropNameInRow="PrevReadDate" msprop:Generator_ColumnPropNameInTable="PrevReadDateColumn" msprop:Generator_UserColumnName="PrevReadDate" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:otherFixed" />
      <xs:field xpath="mstns:BillNo" />
    </xs:unique>
    <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:AptIndexNo" />
    </xs:unique>
    <xs:unique name="UsersMonthly_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UsersMonthly" />
      <xs:field xpath="mstns:IndexNo" />
    </xs:unique>
  </xs:element>
</xs:schema>